﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using CSharpDesign.DAL;

namespace CSharpDesign.BLL
{
    public class XiuGaiShangPinService
    {
        SqlHelper data = new SqlHelper();

        public void UpdateShangpin(string title, string txtBox1, string txtBox2, string txtBox3, string content1, string pic, string selectedValue, string text, string txtBox4, string txtBox5, string id)
        {
            string sql = "update ShangPin set SPName='" + title + "',SPPrice='" + txtBox2 + "',SPNum='" + txtBox3 + "',SPIntroduce='" + content1 + "' ,SPPhoto='" + pic + "',ShangPinFenLeiID='" + selectedValue + "',ShangPinFenLeiName='" + text + "',SPXingHao='" + txtBox1 + "',SPGuiGe='" + txtBox4 + "',SPDanWei='" + txtBox5 + "' where SPID=" + id;
            data.RunSql(sql);
        }
    }
}